package com.geiv.backend.mapper;

import com.geiv.backend.bean.Grade;
import com.geiv.backend.bean.Student;
import com.geiv.backend.result.Student_BaseData;
import com.geiv.backend.result.collectionresult.ResultStudent;
import org.apache.ibatis.annotations.Param;

import java.sql.Date;
import java.util.List;

public interface StudentMapper {
    int deleteByPrimaryKey(Integer sId);

    int insert(Student record);

    int insertSelective(Student record);

    Student selectByPrimaryKey(Integer sId);

    int updateByPrimaryKeySelective(Student record);

    int updateByPrimaryKey(Student record);


    Student selectByUUID(@Param("uuid") String uuid);
    Student selectByStudentId(String sd_id);

    //获取学生基本信息
    Student_BaseData selectResultByStudentId(String sid);
    List<Grade> selectGradesByStudentId(String id);
    List<String> selectSubjectByStudentId(String id);
    List<Date> selectDateByStudentId(String id);

    String studentLogin(@Param("username") String username, @Param("password") String password);
}